SET FOREIGN_KEY_CHECKS = 0;
DROP TABLE IF EXISTS `fa_admin`;
CREATE TABLE `fa_admin` (
  `itemid` varchar(36) NOT NULL COMMENT 'ID',
  `username` varchar(20) NOT NULL DEFAULT '' COMMENT '用户名',
  `nickname` varchar(50) NOT NULL DEFAULT '' COMMENT '昵称',
  `password` varchar(32) NOT NULL DEFAULT '' COMMENT '密码',
  `salt` varchar(30) NOT NULL DEFAULT '' COMMENT '密码盐',
  `avatar` varchar(100) NOT NULL DEFAULT '' COMMENT '头像',
  `email` varchar(100) NOT NULL DEFAULT '' COMMENT '电子邮箱',
  `loginfailure` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '失败次数',
  `logintime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '登录时间',
  `createtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `updatetime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `token` varchar(59) NOT NULL DEFAULT '' COMMENT 'Session标识',
  `status` varchar(30) NOT NULL DEFAULT 'normal' COMMENT '状态',
  `province` varchar(255) NOT NULL DEFAULT '' COMMENT '省份',
  `city` varchar(800) DEFAULT '' COMMENT '城市',
  `area` varchar(1600) DEFAULT '' COMMENT '区县',
  PRIMARY KEY (`itemid`),
  UNIQUE KEY `username` (`username`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='管理员表';

-- ----------------------------
-- Records of fa_admin
-- ----------------------------
BEGIN;
INSERT INTO `fa_admin` VALUES ('3A034451147A732D3B34C8B57C51FCC0', 'admin', 'Andiff', 'aa377c82b31ef12e5c75c168937decde', 'fd1f99', '/assets/img/avatar.png', 'hzhc010@qq.com', '0', '1524307723', '1492186163', '1524307723', '1b394503-7790-4ea8-9b98-aa3a7efa19f8', 'normal', '', '', '');
INSERT INTO `fa_admin` VALUES ('62ff430df6624f998228bbde17cf6383', 'shandong', '山东', 'b578edaf0903f572171423f9970fd4e3', 'yvAKtg', '/assets/img/avatar.png', 'studyset@126.com', '0', '0', '1524404018', '1524404018', '', 'normal', '16,17', '76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,369', '');
INSERT INTO `fa_admin` VALUES ('d734a69a9b3a48a0b529547e358c9576', 'liaoning', '辽宁', '3fa7eab0206e12b10aeb70133f16c8d6', 'chIqY3', '/assets/img/avatar.png', 'ln@126.com', '0', '0', '1524404546', '1524447973', '', 'normal', '8,9', '26,322,317,326', '');
COMMIT;
-- ----------------------------
-- Table structure for fa_admin_log
-- ----------------------------
DROP TABLE IF EXISTS `fa_admin_log`;
CREATE TABLE `fa_admin_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `admin_id` varchar(36) NOT NULL DEFAULT '' COMMENT '管理员ID',
  `username` varchar(30) NOT NULL DEFAULT '' COMMENT '管理员名字',
  `url` varchar(255) NOT NULL DEFAULT '' COMMENT '操作页面',
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT '日志标题',
  `content` text NOT NULL COMMENT '内容',
  `ip` varchar(50) NOT NULL DEFAULT '' COMMENT 'IP',
  `useragent` varchar(255) NOT NULL DEFAULT '' COMMENT 'User-Agent',
  `createtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '操作时间',
  PRIMARY KEY (`id`),
  KEY `name` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='管理员日志表';

-- ----------------------------
-- Table structure for fa_attachment
-- ----------------------------
DROP TABLE IF EXISTS `fa_attachment`;
CREATE TABLE `fa_attachment` (
  `id` int(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `url` varchar(255) NOT NULL DEFAULT '' COMMENT '物理路径',
  `imagewidth` varchar(30) NOT NULL DEFAULT '' COMMENT '宽度',
  `imageheight` varchar(30) NOT NULL DEFAULT '' COMMENT '高度',
  `imagetype` varchar(30) NOT NULL DEFAULT '' COMMENT '图片类型',
  `imageframes` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '图片帧数',
  `filesize` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文件大小',
  `mimetype` varchar(100) NOT NULL DEFAULT '' COMMENT 'mime类型',
  `extparam` varchar(255) NOT NULL DEFAULT '' COMMENT '透传数据',
  `createtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建日期',
  `updatetime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `uploadtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上传时间',
  `storage` enum('local','upyun','qiniu') NOT NULL DEFAULT 'local' COMMENT '存储位置',
  `sha1` varchar(40) NOT NULL DEFAULT '' COMMENT '文件 sha1编码',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='附件表';
-- ----------------------------
-- Records of fa_attachment
-- ----------------------------
BEGIN;
INSERT INTO `fa_attachment` VALUES (1, '/assets/img/qrcode.png', '150', '150', 'png', 0, 21859, 'image/png', '', 1499681848, 1499681848, 1499681848, 'local', '17163603d0263e4838b9387ff2cd4877e8b018f6');
COMMIT;
-- ----------------------------
-- Table structure for fa_auth_group
-- ----------------------------
DROP TABLE IF EXISTS `fa_auth_group`;
CREATE TABLE `fa_auth_group` (
  `itemid` varchar(36) NOT NULL,
  `pid` varchar(36) NOT NULL DEFAULT '' COMMENT '父组别',
  `name` varchar(100) NOT NULL DEFAULT '' COMMENT '组名',
  `rules` text NOT NULL COMMENT '规则ID',
  `createtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `updatetime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` varchar(30) NOT NULL DEFAULT '' COMMENT '状态',
  PRIMARY KEY (`itemid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='分组表';
-- ----------------------------
-- Records of fa_auth_group
-- ----------------------------
BEGIN;
INSERT INTO `fa_auth_group` VALUES ('18faa7d41ec3483c970830470f1db9ff', '88D74E5D3827AD2CC28516C326E52A82', '分管理员12', 'BBBAA66A-B5A4-BAC6-0193-8391A37A58EB,CCC72C5A-1BE6-37C3-854B-EDE9E7BBB7D4,AAA5E25E-CF97-CD3A-80D5-D980B56405A3', '0', '0', 'normal');
INSERT INTO `fa_auth_group` VALUES ('88D74E5D3827AD2CC28516C326E52A82', '', '总管理员', '*', '1490883540', '149088354', 'normal');
INSERT INTO `fa_auth_group` VALUES ('dc18bee162374d3185485c0b29538dc6', '88D74E5D3827AD2CC28516C326E52A82', '分管理员23', 'A005E25E-CF97-CD3A-80D5-D980B56405A3,AAFAA66A-B5A4-BAC6-0193-8391A37A58EB,BB372C5A-1BE6-37C3-854B-EDE9E7BBB7D4', '0', '0', 'normal');
COMMIT;
-- ----------------------------
-- Table structure for fa_auth_group_access
-- ----------------------------
DROP TABLE IF EXISTS `fa_auth_group_access`;
CREATE TABLE `fa_auth_group_access` (
  `uid` varchar(36) NOT NULL DEFAULT '' COMMENT '会员ID',
  `group_id` varchar(36) NOT NULL DEFAULT '' COMMENT '级别ID',
  UNIQUE KEY `uid_group_id` (`uid`,`group_id`),
  KEY `uid` (`uid`),
  KEY `group_id` (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='权限分组表';
-- ----------------------------
-- Records of fa_auth_group_access
-- ----------------------------
BEGIN;
INSERT INTO `fa_auth_group_access` VALUES ('0b55a68602eb4eb58b082b63cfd956a2', '18faa7d41ec3483c970830470f1db9ff');
INSERT INTO `fa_auth_group_access` VALUES ('3A034451147A732D3B34C8B57C51FCC0', '88D74E5D3827AD2CC28516C326E52A82');
INSERT INTO `fa_auth_group_access` VALUES ('62ff430df6624f998228bbde17cf6383', '18faa7d41ec3483c970830470f1db9ff');
INSERT INTO `fa_auth_group_access` VALUES ('b80abe7a8e7f49eab05fb121f09d4687', '18faa7d41ec3483c970830470f1db9ff');
INSERT INTO `fa_auth_group_access` VALUES ('cc4f5e711a9641d7943f262367975d45', '18faa7d41ec3483c970830470f1db9ff');
INSERT INTO `fa_auth_group_access` VALUES ('d734a69a9b3a48a0b529547e358c9576', 'dc18bee162374d3185485c0b29538dc6');
COMMIT;
-- ----------------------------
-- Table structure for fa_auth_rule
-- ----------------------------
DROP TABLE IF EXISTS `fa_auth_rule`;
CREATE TABLE `fa_auth_rule` (
  `itemid` varchar(36) NOT NULL,
  `type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '1:menu,2:file',
  `pid` varchar(36) NOT NULL DEFAULT '' COMMENT '父ID',
  `name` varchar(100) NOT NULL DEFAULT '' COMMENT '规则名称',
  `title` varchar(50) NOT NULL DEFAULT '' COMMENT '规则名称',
  `icon` varchar(50) NOT NULL DEFAULT '' COMMENT '图标',
  `condition` varchar(255) NOT NULL DEFAULT '' COMMENT '条件',
  `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
  `ismenu` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否为菜单',
  `createtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `updatetime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `weigh` int(10) NOT NULL DEFAULT '0' COMMENT '权重',
  `status` varchar(30) NOT NULL DEFAULT '' COMMENT '状态',
  PRIMARY KEY (`itemid`),
  UNIQUE KEY `name` (`name`) USING BTREE,
  KEY `pid` (`pid`),
  KEY `weigh` (`weigh`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='节点表';

-- ----------------------------
-- Records of fa_auth_rule
-- ----------------------------
BEGIN;
INSERT INTO `fa_auth_rule` VALUES ('024E71E6-59AD-5624-478E-4EEB7B4D97A4', '1', '7CB0A500-0947-E0B9-B9F5-24211CFDBF06', 'auth/group/edit', 'Edit', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '106', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('078CF00C-AD2E-D441-DBCC-24A2C74897A4', '1', 'B132AB73-1576-16B1-FEDF-A3E067905617', 'addon/uninstall', 'Uninstall', 'fa fa-circle-o', '', '', '0', '1502035509', '1502035509', '0', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('08EF64FE-A44C-658F-2AD4-1893C701C750', '1', '4220ED07-D996-ED9D-F3AB-D0F2E8BD5D92', 'user/group/edit', 'Edit', 'fa fa-circle-o', '', '', '0', '1516374729', '1516374729', '0', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('0D2BAE9A-2625-710A-95F3-C1C8B7D30260', '1', '9C0A037F-4F08-9532-83DC-3616777A5643', 'dashboard/multi', 'Multi', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '132', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('0EE54242-5306-13AE-08D9-93C51F7A6A2C', '1', '8DD548A6-003C-8AC3-0A80-1045B9DB3736', 'general/profile/edit', 'Edit', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '30', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('0F846095-73A3-4F8E-EBAB-64AB4C029D29', '1', 'B132AB73-1576-16B1-FEDF-A3E067905617', 'addon/install', 'Install', 'fa fa-circle-o', '', '', '0', '1502035509', '1502035509', '0', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('11D7DDCA-16EB-E788-79A0-702270126BB2', '1', '8DD548A6-003C-8AC3-0A80-1045B9DB3736', 'general/profile/update', 'Update profile', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '32', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('11F42C9C-7E4E-CB1A-8933-7C590E5EFA05', '1', '9C0A037F-4F08-9532-83DC-3616777A5643', 'dashboard/index', 'View', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '136', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('1421613C-31E6-E25F-8144-CB0D6471B761', '1', '53E5AB24-D4A7-A804-D8DC-42C55328BCB8', 'category/add', 'Add', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '141', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('14D96F27-F994-AFD2-16A6-42519C0D0CEE', '1', '98604441-AA99-C37B-A711-EC8814F015AD', 'general/attachment/del', 'Delete', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '55', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('155C7E18-4C81-F2A9-7D53-DF00E10F8C41', '1', '53E5AB24-D4A7-A804-D8DC-42C55328BCB8', 'category/index', 'View', 'fa fa-circle-o', '', 'Category tips', '0', '1497429920', '1497429920', '142', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('168AE1D1-DFE3-5766-E4F2-E4DD3899AB8D', '1', '7CB0A500-0947-E0B9-B9F5-24211CFDBF06', 'auth/group/index', 'View', 'fa fa-circle-o', '', 'Group tips', '0', '1497429920', '1497429920', '108', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('19EED6A3-7F8A-E9BF-2C2D-710E8B77DCB3', '1', '4220ED07-D996-ED9D-F3AB-D0F2E8BD5D92', 'user/group/multi', 'Multi', 'fa fa-circle-o', '', '', '0', '1516374729', '1516374729', '0', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('1AD4F4B4-BDE4-5446-5C1F-988561A5AE04', '1', '80836700-1A24-F436-C78B-ABB8D59EB5D3', 'auth/adminlog', 'Admin log', 'fa fa-list-alt', '', 'Admin log tips', '1', '1497429920', '1497430307', '113', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('1FA08705-1C09-0A19-0616-DC596AD74FD4', '1', '4D355D7F-686C-4CA4-D1B9-4E9925E98384', 'user/user/add', 'Add', 'fa fa-circle-o', '', '', '0', '1516374729', '1516374729', '0', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('24ACCB3E-F7C4-A3F1-628B-40FA329D245F', '1', 'B132AB73-1576-16B1-FEDF-A3E067905617', 'addon/local', 'Local install', 'fa fa-circle-o', '', '', '0', '1502035509', '1502035509', '0', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('29A17AAD-0FFC-A9AE-673C-211B9634495F', '1', '7674E83D-6B51-A274-7CAC-01FD2000F1A1', 'auth/admin/add', 'Add', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '116', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('2BB5B5AF-AA9E-54F4-BC9B-545A6E581CB9', '1', '1AD4F4B4-BDE4-5446-5C1F-988561A5AE04', 'auth/adminlog/index', 'View', 'fa fa-circle-o', '', 'Admin log tips', '0', '1497429920', '1497429920', '112', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('2EBB336F-187C-260D-DB76-32D9CF2097BA', '1', '4220ED07-D996-ED9D-F3AB-D0F2E8BD5D92', 'user/group/add', 'Add', 'fa fa-circle-o', '', '', '0', '1516374729', '1516374729', '0', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('30AAEE08-81AD-B489-4265-6022886518C6', '1', '8DD548A6-003C-8AC3-0A80-1045B9DB3736', 'general/profile/add', 'Add', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '31', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('356B6DED-AFB6-3EFD-6382-C0C4C4BDEB4A', '1', '8DD548A6-003C-8AC3-0A80-1045B9DB3736', 'general/profile/index', 'View', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '33', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('3856CF55-8C88-306D-4B1A-52A941753772', '1', '98604441-AA99-C37B-A711-EC8814F015AD', 'general/attachment/select', 'Select attachment', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '58', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('3DFC3210-81C8-9CEF-AAC5-AF30AE5DA8FA', '1', 'B132AB73-1576-16B1-FEDF-A3E067905617', 'addon/refresh', 'Refresh', 'fa fa-circle-o', '', '', '0', '1502035509', '1502035509', '0', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('406042D0-27BC-3C34-DC4A-85C59A7C318B', '1', '4220ED07-D996-ED9D-F3AB-D0F2E8BD5D92', 'user/group/del', 'Del', 'fa fa-circle-o', '', '', '0', '1516374729', '1516374729', '0', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('42CB6B8B-5E44-7F19-000A-39C919C0A915', '1', '57652612-444C-E802-8F7B-763244E78C0D', 'auth/rule/del', 'Delete', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '100', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('4A60C4FD-4292-6254-8D8A-7DC397005FC2', '1', '98604441-AA99-C37B-A711-EC8814F015AD', 'general/attachment/multi', 'Multi', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '54', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('4B502263-B6A6-E7D2-D724-C6812B3AF8C1', '1', '', 'general', 'General', 'fa fa-cogs', '', '', '1', '1497429920', '1497430169', '137', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('4BA192DE-D565-F82C-4AB3-8930E69ABBC4', '1', 'D3D5A8FC-2236-5D7E-4DBC-45BFEEB18317', 'general/config/del', 'Delete', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '49', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('505743CF-B058-4746-CBB3-D000872F21E2', '1', 'B132AB73-1576-16B1-FEDF-A3E067905617', 'addon/add', 'Add', 'fa fa-circle-o', '', '', '0', '1502035509', '1502035509', '0', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('509A17F2-A67D-6D21-8A40-942A4061A530', '1', 'D6E5A41B-2083-DB13-16FA-F07D326C4F60', 'user/rule/multi', 'Multi', 'fa fa-circle-o', '', '', '0', '1516374729', '1516374729', '0', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('528D6D8C-5A4E-C419-6276-94A381416DAD', '1', '4D355D7F-686C-4CA4-D1B9-4E9925E98384', 'user/user/multi', 'Multi', 'fa fa-circle-o', '', '', '0', '1516374729', '1516374729', '0', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('53E5AB24-D4A7-A804-D8DC-42C55328BCB8', '1', '', 'category', 'Category', 'fa fa-list', '', 'Category tips', '1', '1497429920', '1497429920', '119', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('57652612-444C-E802-8F7B-763244E78C0D', '1', '80836700-1A24-F436-C78B-ABB8D59EB5D3', 'auth/rule', 'Rule', 'fa fa-bars', '', 'Rule tips', '1', '1497429920', '1497430581', '104', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('586B63D5-186B-69BD-FA57-3B6837ACBDC1', '1', '8DD548A6-003C-8AC3-0A80-1045B9DB3736', 'general/profile/multi', 'Multi', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '28', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('594ED96F-4CA6-EF54-AC14-A93E368BA0A4', '1', 'B132AB73-1576-16B1-FEDF-A3E067905617', 'addon/config', 'Setting', 'fa fa-circle-o', '', '', '0', '1502035509', '1502035509', '0', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('5B2222A4-2C82-8506-1B57-03AD202A65CF', '1', 'D6E5A41B-2083-DB13-16FA-F07D326C4F60', 'user/rule/del', 'Del', 'fa fa-circle-o', '', '', '0', '1516374729', '1516374729', '0', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('6759ED64-C093-1131-2517-661B7E558A54', '1', 'B132AB73-1576-16B1-FEDF-A3E067905617', 'addon/state', 'Update state', 'fa fa-circle-o', '', '', '0', '1502035509', '1502035509', '0', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('67A60027-5C14-C987-A309-0025FC365B13', '1', 'D3D5A8FC-2236-5D7E-4DBC-45BFEEB18317', 'general/config/add', 'Add', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '51', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('761D8406-D7FA-C784-3629-444A9C25195F', '1', 'D3D5A8FC-2236-5D7E-4DBC-45BFEEB18317', 'general/config/edit', 'Edit', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '50', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('7674E83D-6B51-A274-7CAC-01FD2000F1A1', '1', '80836700-1A24-F436-C78B-ABB8D59EB5D3', 'auth/admin', 'Admin', 'fa fa-user', '', 'Admin tips', '1', '1497429920', '1497430320', '118', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('7CB0A500-0947-E0B9-B9F5-24211CFDBF06', '1', '80836700-1A24-F436-C78B-ABB8D59EB5D3', 'auth/group', 'Group', 'fa fa-group', '', 'Group tips', '1', '1497429920', '1497429920', '109', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('7DBB0EC3-72E4-78BB-5461-BA0231935026', '1', '98604441-AA99-C37B-A711-EC8814F015AD', 'general/attachment/edit', 'Edit', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '56', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('80836700-1A24-F436-C78B-ABB8D59EB5D3', '1', '', 'auth', 'Auth', 'fa fa-group', '', '', '1', '1497429920', '1497430092', '99', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('831AC815-8DF7-95C0-8D93-35CB7C9DCA12', '1', '7674E83D-6B51-A274-7CAC-01FD2000F1A1', 'auth/admin/del', 'Delete', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '114', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('83DA218E-96E1-7A34-8A31-D89B6AE1FFA3', '1', 'D6E5A41B-2083-DB13-16FA-F07D326C4F60', 'user/rule/edit', 'Edit', 'fa fa-circle-o', '', '', '0', '1516374729', '1516374729', '0', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('8DD548A6-003C-8AC3-0A80-1045B9DB3736', '1', '4B502263-B6A6-E7D2-D724-C6812B3AF8C1', 'general/profile', 'Profile', 'fa fa-user', '', '', '1', '1497429920', '1497429920', '34', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('8EAF4B73-BDE5-A0BA-4DCB-B0481A5A89F6', '1', '1AD4F4B4-BDE4-5446-5C1F-988561A5AE04', 'auth/adminlog/del', 'Delete', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '110', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('8FD8D6A6-E2F9-2CF4-6EAB-6B1DB829F28C', '1', '1AD4F4B4-BDE4-5446-5C1F-988561A5AE04', 'auth/adminlog/detail', 'Detail', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '111', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('92466EEC-75F0-C76B-BC55-02CEA47C9413', '1', '7CB0A500-0947-E0B9-B9F5-24211CFDBF06', 'auth/group/add', 'Add', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '107', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('940B4298-9A49-26F2-EA0C-FD4A2F7B7DD4', '1', '57652612-444C-E802-8F7B-763244E78C0D', 'auth/rule/edit', 'Edit', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '101', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('95BDD3B2-79EB-E50C-D4B0-E34328CA26BA', '1', '4D355D7F-686C-4CA4-D1B9-4E9925E98384', 'user/user/del', 'Del', 'fa fa-circle-o', '', '', '0', '1516374729', '1516374729', '0', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('98604441-AA99-C37B-A711-EC8814F015AD', '1', '4B502263-B6A6-E7D2-D724-C6812B3AF8C1', 'general/attachment', 'Attachment', 'fa fa-file-image-o', '', 'Attachment tips', '1', '1497429920', '1497430699', '53', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('9C0A037F-4F08-9532-83DC-3616777A5643', '1', '', 'dashboard', 'Dashboard', 'fa fa-dashboard', '', 'Dashboard tips', '1', '1497429920', '1497429920', '143', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('A005E25E-CF97-CD3A-80D5-D980B56405A3', '1', '', 'module', '模型管理', 'fa fa-database', '', '', '1', '1518020876', '1518020876', '56', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('AAFZZ66A-B5A4-BAC6-0193-8391A37A58EB', '1', 'A005E25E-CF97-CD3A-80D5-D980B56405A3', 'module/getindex', '模型库', 'fa fa-database', '', '', '1', '1518021086', '1518021086', '3', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('AA0652BC-4B62-3D82-397C-D8E1B1061A5E', '1', '4D355D7F-686C-4CA4-D1B9-4E9925E98384', 'user/user/edit', 'Edit', 'fa fa-circle-o', '', '', '0', '1516374729', '1516374729', '0', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('AA6BF341-2187-6070-231E-E84D7478C57E', '1', '57652612-444C-E802-8F7B-763244E78C0D', 'auth/rule/index', 'View', 'fa fa-circle-o', '', 'Rule tips', '0', '1497429920', '1497429920', '103', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('AA6D6B2D-7EF7-FF19-8695-71772C1663AA', '1', 'B132AB73-1576-16B1-FEDF-A3E067905617', 'addon/multi', 'Multi', 'fa fa-circle-o', '', '', '0', '1502035509', '1502035509', '0', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('AAA5E25E-CF97-CD3A-80D5-D980B56405A3', '1', '', 'test', '测试管理', 'fa fa-database', '', '', '1', '1518020876', '1518020876', '56', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('AAFAA66A-B5A4-BAC6-0193-8391A37A58EB', '1', 'A005E25E-CF97-CD3A-80D5-D980B56405A3', 'module/index', '模型列表', 'fa fa-database', '', '', '1', '1518021086', '1518021086', '8', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('ADBDEE12-96A7-0EC7-3C37-2A6672A09F3C', '1', '7674E83D-6B51-A274-7CAC-01FD2000F1A1', 'auth/admin/index', 'View', 'fa fa-circle-o', '', 'Admin tips', '0', '1497429920', '1497429920', '117', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('B10B2EA0-D8AA-54BF-D393-3324376F6DDE', '1', '57652612-444C-E802-8F7B-763244E78C0D', 'auth/rule/add', 'Add', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '102', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('B132AB73-1576-16B1-FEDF-A3E067905617', '1', '', 'addon', 'Addon', 'fa fa-rocket', '', 'Addon tips', '1', '1502035509', '1502035509', '0', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('B89D2617-CFAF-8B35-CD0A-285775741321', '1', '9C0A037F-4F08-9532-83DC-3616777A5643', 'dashboard/add', 'Add', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '135', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('BB372C5A-1BE6-37C3-854B-EDE9E7BBB7D4', '1', 'A005E25E-CF97-CD3A-80D5-D980B56405A3', 'module/add', '添加模型', 'fa fa-database', '', '', '1', '1518021162', '1518021162', '4', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('BBBAA66A-B5A4-BAC6-0193-8391A37A58EB', '1', 'AAA5E25E-CF97-CD3A-80D5-D980B56405A3', 'test/index', '测试列表', 'fa fa-database', '', '', '1', '1518021086', '1518021086', '18', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('BE88AD5F-2911-F360-9389-FD61E11DEDD8', '1', '53E5AB24-D4A7-A804-D8DC-42C55328BCB8', 'category/del', 'Delete', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '139', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('C01AF3F4-9C73-04D2-CB44-AAD35FF4AC3A', '1', 'D3D5A8FC-2236-5D7E-4DBC-45BFEEB18317', 'general/config/index', 'View', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '52', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('C36855F0-AA41-ECDA-8EB3-66CB3DD543CB', '1', '7CB0A500-0947-E0B9-B9F5-24211CFDBF06', 'auth/group/del', 'Delete', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '105', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('C433262A-161C-2B29-F2BC-78894F28DFFB', '1', '98604441-AA99-C37B-A711-EC8814F015AD', 'general/attachment/add', 'Add', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '57', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('C5EF0763-809D-8020-D226-7F0C185AAC6A', '1', 'D3D5A8FC-2236-5D7E-4DBC-45BFEEB18317', 'general/config/multi', 'Multi', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '48', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('C754A740-770F-EAAE-25EA-9F75A301ED3C', '1', '9C0A037F-4F08-9532-83DC-3616777A5643', 'dashboard/del', 'Delete', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '133', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('C7CA5C7A-444F-D9F2-DA85-09BEC4AF347D', '1', '9C0A037F-4F08-9532-83DC-3616777A5643', 'dashboard/edit', 'Edit', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '134', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('CB80DF21-5AD5-F889-B275-667D3EF9F7F6', '1', 'B132AB73-1576-16B1-FEDF-A3E067905617', 'addon/del', 'Delete', 'fa fa-circle-o', '', '', '0', '1502035509', '1502035509', '0', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('CCC72C5A-1BE6-37C3-854B-EDE9E7BBB7D4', '1', 'AAA5E25E-CF97-CD3A-80D5-D980B56405A3', 'test/add', '添加测试', 'fa fa-database', '', '', '1', '1518021162', '1518021162', '14', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('D02D4C81-2F7A-8855-507A-CF9AC6568735', '1', '7674E83D-6B51-A274-7CAC-01FD2000F1A1', 'auth/admin/edit', 'Edit', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '115', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('D3D5A8FC-2236-5D7E-4DBC-45BFEEB18317', '1', '4B502263-B6A6-E7D2-D724-C6812B3AF8C1', 'general/config', 'Config', 'fa fa-cog', '', 'Config tips', '1', '1497429920', '1497430683', '60', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('D961C95F-7A08-F2C7-F1B3-C3A1F35BA80A', '1', '', 'user', 'User', 'fa fa-list', '', '', '1', '1516374729', '1516374729', '0', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('EA346153-055B-0ACA-A6B2-98798F12E660', '1', '4220ED07-D996-ED9D-F3AB-D0F2E8BD5D92', 'user/group/index', 'View', 'fa fa-circle-o', '', '', '0', '1516374729', '1516374729', '0', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('EABF92DB-A846-C2D2-62CD-8F7D36CB7CBA', '1', '4D355D7F-686C-4CA4-D1B9-4E9925E98384', 'user/user/index', 'View', 'fa fa-circle-o', '', '', '0', '1516374729', '1516374729', '0', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('EF3543CB-F212-8572-62A7-2AF64AD02C35', '1', '53E5AB24-D4A7-A804-D8DC-42C55328BCB8', 'category/multi', 'Multi', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '138', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('EF4793F5-3648-AE0E-A270-47D96C51831E', '1', 'B132AB73-1576-16B1-FEDF-A3E067905617', 'addon/edit', 'Edit', 'fa fa-circle-o', '', '', '0', '1502035509', '1502035509', '0', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('F53431F9-57BD-89AE-69FA-1577B54589F4', '1', 'D6E5A41B-2083-DB13-16FA-F07D326C4F60', 'user/rule/index', 'View', 'fa fa-circle-o', '', '', '0', '1516374729', '1516374729', '0', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('F89BEDE5-A385-2B17-3EEE-7FE134953F9D', '1', '98604441-AA99-C37B-A711-EC8814F015AD', 'general/attachment/index', 'View', 'fa fa-circle-o', '', 'Attachment tips', '0', '1497429920', '1497429920', '59', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('F92D3099-3818-5565-60E4-87ED319B6FFF', '1', '8DD548A6-003C-8AC3-0A80-1045B9DB3736', 'general/profile/del', 'Delete', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '29', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('FA604A65-BBC3-0385-4581-E7482735B93B', '1', 'B132AB73-1576-16B1-FEDF-A3E067905617', 'addon/index', 'View', 'fa fa-circle-o', '', 'Addon tips', '0', '1502035509', '1502035509', '0', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('FD7FF8B5-F994-14A8-F88F-480E06D6A0EE', '1', '53E5AB24-D4A7-A804-D8DC-42C55328BCB8', 'category/edit', 'Edit', 'fa fa-circle-o', '', '', '0', '1497429920', '1497429920', '140', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('FF831D5F-26F4-8D13-1D27-57AE303D2AC7', '1', 'D6E5A41B-2083-DB13-16FA-F07D326C4F60', 'user/rule/add', 'Add', 'fa fa-circle-o', '', '', '0', '1516374729', '1516374729', '0', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('1688acc13dd948fabaa0d13988f87acf', '1', 'D961C95F-7A08-F2C7-F1B3-C3A1F35BA80A', 'member/membergroup/index', '会员组列表', 'fa fa-circle-o', '', '', '1', '1525168611', '1525168611', '100', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('2af324267a9b440880df8a66fb8526dc', '1', 'D961C95F-7A08-F2C7-F1B3-C3A1F35BA80A', 'member/membergroup/add', '添加会员组', 'fa fa-circle-o', '', '', '1', '1525168611', '1525168611', '99', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('569be73bf10142c5a77121b32a1fa98f', '1', 'D961C95F-7A08-F2C7-F1B3-C3A1F35BA80A', 'member/memberlogin/add', '添加会员登录', 'fa fa-circle-o', '', '', '1', '1525157260', '1525157260', '19', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('62d0f8af6c634533aae040deb5c76534', '1', 'D961C95F-7A08-F2C7-F1B3-C3A1F35BA80A', 'member/memberrule/add', '添加会员权限', 'fa fa-circle-o', '', '', '1', '1525178898', '1525178898', '199', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('ac03fa82c24d4373a0f8936646cf7e16', '1', 'D961C95F-7A08-F2C7-F1B3-C3A1F35BA80A', 'member/memberrule/index', '会员权限列表', 'fa fa-circle-o', '', '', '1', '1525178898', '1525178898', '200', 'normal');
INSERT INTO `fa_auth_rule` VALUES ('e59169c91a734be29d25be59055f8465', '1', 'D961C95F-7A08-F2C7-F1B3-C3A1F35BA80A', 'member/memberlogin/index', '会员登录列表', 'fa fa-circle-o', '', '', '1', '1525157260', '1525157260', '21', 'normal');
COMMIT;
-- ----------------------------
-- Table structure for fa_category
-- ----------------------------
DROP TABLE IF EXISTS `fa_category`;
CREATE TABLE `fa_category` (
  `itemid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父ID',
  `child` smallint(4) NOT NULL DEFAULT '0' COMMENT '子类数量',
  `type` varchar(30) NOT NULL DEFAULT '' COMMENT '栏目类型',
  `name` varchar(30) NOT NULL DEFAULT '',
  `nickname` varchar(50) NOT NULL DEFAULT '',
  `flag` set('hot','index','recommend') NOT NULL DEFAULT '',
  `thumb` varchar(100) NOT NULL DEFAULT '' COMMENT '图片',
  `color` varchar(100) NOT NULL DEFAULT '' COMMENT '颜色',
  `keywords` varchar(255) NOT NULL DEFAULT '' COMMENT '关键字',
  `description` varchar(255) NOT NULL DEFAULT '' COMMENT '描述',
  `diyname` varchar(30) NOT NULL DEFAULT '' COMMENT '自定义名称',
  `dirname` varchar(50) NOT NULL DEFAULT '' COMMENT '文件夹名称',
  `createtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `updatetime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `weigh` int(10) NOT NULL DEFAULT '0' COMMENT '权重',
  `status` varchar(30) NOT NULL DEFAULT '' COMMENT '状态',
  `linkurl` varchar(255) DEFAULT '' COMMENT '链接',
  PRIMARY KEY (`itemid`),
  KEY `weigh` (`weigh`,`itemid`),
  KEY `pid` (`pid`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='分类表';

-- ----------------------------
-- Records of fa_category
-- ----------------------------
BEGIN;
INSERT INTO `fa_category` VALUES ('1', '0', '8', 'default', '网站栏目', 'news', 'recommend', '/assets/img/qrcode.png', '', '网站栏目', '网站栏目', 'news','', '1495262190', '1525089025', '1', 'normal', '');
INSERT INTO `fa_category` VALUES ('18', '1', '0', '', '图谱', '', '', '', '', '图谱', '图谱', '', '','1525089076', '1525873065', '6', 'normal', '/index/xinwen/list?catid=18');
INSERT INTO `fa_category` VALUES ('19', '1', '5', '', '资讯', '', '', '', '', '资讯', '资讯', '', '', '1525089088', '1525504617', '9', 'normal', '');
INSERT INTO `fa_category` VALUES ('20', '1', '0', '', '评级', '', '', '', '', '评级', '评级', '', '', '1525089099', '1525504939', '7', 'normal', '');
INSERT INTO `fa_category` VALUES ('21', '1', '0', '', '问答', '', '', '', '', '问答', '问答', '', '', '1525089132', '1525762375', '8', 'normal', '');
INSERT INTO `fa_category` VALUES ('22', '19', '0', '', '新闻', '', '', '', '', '新闻', '新闻', '', '', '1525089833', '1525415170', '13', 'normal', '');
INSERT INTO `fa_category` VALUES ('23', '19', '0', '', '融资', '', '', '', '', '融资', '融资', '', '', '1525089844', '1525415186', '12', 'normal', '');
INSERT INTO `fa_category` VALUES ('27', '19', '0', '', '政策', '', '', '', '', '政策', '政策', '', '', '1525415120', '1525415206', '11', 'normal', '');
INSERT INTO `fa_category` VALUES ('28', '19', '0', '', '路演', '', '', '', '', '路演', '路演', '', '', '1525415229', '1525415229', '10', 'normal', '');
INSERT INTO `fa_category` VALUES ('29', '19', '0', '', '百科', '', '', '', '', '百科', '百科', '', '', '1525415247', '1525415247', '9', 'normal', '');
INSERT INTO `fa_category` VALUES ('32', '1', '0', '', '行研', '', '', '', '', '行研', '行研', '', '', '1525505196', '1525505196', '4', 'normal', '');
INSERT INTO `fa_category` VALUES ('34', '1', '0', '', '行情', '', '', '', '', '行情', '行情', '', '', '1525505307', '1525873085', '5', 'normal', '/index/xinwen/list?catid=34');
COMMIT;

-- ----------------------------
-- Table structure for fa_config
-- ----------------------------
DROP TABLE IF EXISTS `fa_config`;
CREATE TABLE `fa_config` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL DEFAULT '' COMMENT '变量名',
  `group` varchar(30) NOT NULL DEFAULT '' COMMENT '分组',
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT '变量标题',
  `tip` varchar(100) NOT NULL DEFAULT '' COMMENT '变量描述',
  `type` varchar(30) NOT NULL DEFAULT '' COMMENT '类型:string,text,int,bool,array,datetime,date,file',
  `value` text NOT NULL COMMENT '变量值',
  `content` text NOT NULL COMMENT '变量字典数据',
  `rule` varchar(100) NOT NULL DEFAULT '' COMMENT '验证规则',
  `extend` varchar(255) NOT NULL DEFAULT '' COMMENT '扩展属性',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='系统配置';

-- ----------------------------
-- Records of fa_config
-- ----------------------------
BEGIN;
INSERT INTO `fa_config` VALUES ('1', 'name', 'basic', 'Site name', '请填写站点名称', 'string', 'AndiffCMS', '', 'required', '');
INSERT INTO `fa_config` VALUES ('2', 'beian', 'basic', 'Beian', '粤ICP备15054802号-4', 'string', '京ICP备15019846号-2', '', '', '');
INSERT INTO `fa_config` VALUES ('3', 'cdnurl', 'basic', 'Cdn url', '如果静态资源使用第三方云储存请配置该值', 'string', '', '', '', '');
INSERT INTO `fa_config` VALUES ('4', 'version', 'basic', 'Version', '如果静态资源有变动请重新配置该值', 'string', '1.0.1', '', 'required', '');
INSERT INTO `fa_config` VALUES ('5', 'timezone', 'basic', 'Timezone', '', 'string', 'Asia/Shanghai', '', 'required', '');
INSERT INTO `fa_config` VALUES ('6', 'forbiddenip', 'basic', 'Forbidden ip', '一行一条记录', 'text', '', '', '', '');
INSERT INTO `fa_config` VALUES ('7', 'languages', 'basic', 'Languages', '', 'array', '{\"backend\":\"zh-cn\",\"frontend\":\"zh-cn\"}', '', 'required', '');
INSERT INTO `fa_config` VALUES ('8', 'fixedpage', 'basic', 'Fixed page', '请尽量输入左侧菜单栏存在的链接', 'string', 'dashboard', '', 'required', '');
INSERT INTO `fa_config` VALUES ('9', 'categorytype', 'dictionary', 'Category type', '', 'array', '{\"default\":\"Default\",\"page\":\"Page\",\"article\":\"Article\"}', '', '', '');
INSERT INTO `fa_config` VALUES ('10', 'configgroup', 'dictionary', 'Config group', '', 'array', '{\"basic\":\"Basic\",\"email\":\"Email\",\"dictionary\":\"Dictionary\",\"user\":\"User\",\"example\":\"Example\"}', '', '', '');
INSERT INTO `fa_config` VALUES ('11', 'mail_type', 'email', 'Mail type', '选择邮件发送方式', 'select', '1', '[\"Please select\",\"SMTP\",\"Mail\"]', '', '');
INSERT INTO `fa_config` VALUES ('12', 'mail_smtp_host', 'email', 'Mail smtp host', '错误的配置发送邮件会导致服务器超时', 'string', 'smtp.163.com', '', '', '');
INSERT INTO `fa_config` VALUES ('13', 'mail_smtp_port', 'email', 'Mail smtp port', '(不加密默认25,SSL默认465,TLS默认587)', 'string', '25', '', '', '');
INSERT INTO `fa_config` VALUES ('14', 'mail_smtp_user', 'email', 'Mail smtp user', '（填写完整用户名）', 'string', 'andiff@163.com', '', '', '');
INSERT INTO `fa_config` VALUES ('15', 'mail_smtp_pass', 'email', 'Mail smtp password', '（填写您的密码）', 'string', '54321l', '', '', '');
INSERT INTO `fa_config` VALUES ('16', 'mail_verify_type', 'email', 'Mail vertify type', '（SMTP验证方式[推荐SSL]）', 'select', '0', '[\"None\",\"TLS\",\"SSL\"]', '', '');
INSERT INTO `fa_config` VALUES ('17', 'mail_from', 'email', 'Mail from', '', 'string', 'andiff@163.com', '', '', '');
INSERT INTO `fa_config` VALUES ('18', 'accessgroup', 'basic', 'Access Control', '权限控制(省:province,市:city)', 'string', 'all', '', '', '');
COMMIT;

-- ----------------------------
-- Table structure for fa_ems
-- ----------------------------
DROP TABLE IF EXISTS `fa_ems`;
CREATE TABLE `fa_ems`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `event` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '事件',
  `email` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '邮箱',
  `code` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '验证码',
  `times` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '验证次数',
  `ip` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'IP',
  `createtime` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='邮箱验证码表';

-- ----------------------------
-- Table structure for fa_sms
-- ----------------------------
DROP TABLE IF EXISTS `fa_sms`;
CREATE TABLE `fa_sms` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `event` varchar(30) NOT NULL DEFAULT '' COMMENT '事件',
  `mobile` varchar(20) NOT NULL DEFAULT '' COMMENT '手机号',
  `code` varchar(10) NOT NULL DEFAULT '' COMMENT '验证码',
  `times` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '验证次数',
  `ip` varchar(30) NOT NULL DEFAULT '' COMMENT 'IP',
  `createtime` int(10) unsigned DEFAULT '0' COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='短信验证码表';

-- ----------------------------
-- Table structure for fa_test
-- ----------------------------
DROP TABLE IF EXISTS `fa_test`;
CREATE TABLE `fa_test` (
  `content` text COMMENT '内容',
  `payment` varchar(100) NOT NULL DEFAULT '1' COMMENT '付费方式',
  `catid` int(10) NOT NULL DEFAULT '0' COMMENT '类别',
  `place` smallint(4) NOT NULL DEFAULT '1' COMMENT '渠道',
  `gender` tinyint(1) NOT NULL DEFAULT '1' COMMENT '性别',
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT '名称',
  `itemid` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
  PRIMARY KEY (`itemid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='测试表';


-- ----------------------------
-- Records of fa_test
-- ----------------------------
BEGIN;
INSERT INTO `fa_test` VALUES ('<p><span style=\"color: rgb(51, 51, 51); font-family: arial; font-size: small;\">腾讯</span><span style=\"color: rgb(204, 0, 0); font-family: arial; font-size: small;\">视频</span><span style=\"color: rgb(51, 51, 51); font-family: arial; font-size: small;\">电视剧 综艺 电影 VIP影院 动漫 三国机密之潜龙在渊 独孤天</span></p><p><img src=\"https://qd.andiff.net/summernote/162445941.jpg\" data-filename=\"image name\" style=\"width: 50%;\"><span style=\"color: rgb(51, 51, 51); font-family: arial; font-size: small;\"><br></span><br></p>', '2', '4', '2', '1', '测试标题', '1');
COMMIT;

-- ----------------------------
-- Table structure for fa_user
-- ----------------------------
DROP TABLE IF EXISTS `fa_user`;
CREATE TABLE `fa_user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `group_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '组别ID',
  `username` varchar(32) NOT NULL DEFAULT '' COMMENT '用户名',
  `nickname` varchar(50) NOT NULL DEFAULT '' COMMENT '昵称',
  `password` varchar(32) NOT NULL DEFAULT '' COMMENT '密码',
  `salt` varchar(30) NOT NULL DEFAULT '' COMMENT '密码盐',
  `email` varchar(100) NOT NULL DEFAULT '' COMMENT '电子邮箱',
  `mobile` varchar(11) NOT NULL DEFAULT '' COMMENT '手机号',
  `avatar` varchar(255) NOT NULL DEFAULT '' COMMENT '头像',
  `level` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '等级',
  `gender` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '性别',
  `birthday` date COMMENT '生日',
  `bio` varchar(100) NOT NULL DEFAULT '' COMMENT '格言',
  `score` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '积分',
  `successions` int(10) unsigned NOT NULL DEFAULT '1' COMMENT '连续登录天数',
  `maxsuccessions` int(10) unsigned NOT NULL DEFAULT '1' COMMENT '最大连续登录天数',
  `prevtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上次登录时间',
  `logintime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '登录时间',
  `loginip` varchar(50) NOT NULL DEFAULT '' COMMENT '登录IP',
  `loginfailure` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '失败次数',
  `joinip` varchar(50) NOT NULL DEFAULT '' COMMENT '加入IP',
  `jointime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '加入时间',
  `createtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `updatetime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `token` varchar(50) NOT NULL DEFAULT '' COMMENT 'Token',
  `status` varchar(30) NOT NULL DEFAULT '' COMMENT '状态',
  `verification` varchar(255) NOT NULL DEFAULT '' COMMENT '验证',
  PRIMARY KEY (`id`),
  KEY `username` (`username`),
  KEY `email` (`email`),
  KEY `mobile` (`mobile`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='会员表';

-- ----------------------------
-- Records of fa_user
-- ----------------------------
BEGIN;
INSERT INTO `fa_user` VALUES (1, 1, 'admin', 'admin', 'c13f62012fd6a8fdf06b3452a94430e5', 'rpR6Bv', 'admin@163.com', '13888888888', '/assets/img/avatar.png', 0, 0, '2017-04-15', '', 0, 1, 1, 1516170492, 1516171614, '127.0.0.1', 0, '127.0.0.1', 1491461418, 0, 1516171614, '', 'normal','');
COMMIT;

-- ----------------------------
-- Table structure for fa_user_group
-- ----------------------------
DROP TABLE IF EXISTS `fa_user_group`;
CREATE TABLE `fa_user_group` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT '' COMMENT '组名',
  `rules` text COMMENT '权限节点',
  `createtime` int(10) DEFAULT NULL COMMENT '添加时间',
  `updatetime` int(10) DEFAULT NULL COMMENT '更新时间',
  `status` enum('normal','hidden') DEFAULT NULL COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='会员组表';

-- ----------------------------
-- Records of fa_user_group
-- ----------------------------
BEGIN;
INSERT INTO `fa_user_group` VALUES (1, '默认组', '1,2,3,4,5,6,7,8,9,10,11,12', 1515386468, 1516168298, 'normal');
COMMIT;

-- ----------------------------
-- Table structure for fa_user_rule
-- ----------------------------
DROP TABLE IF EXISTS `fa_user_rule`;
CREATE TABLE `fa_user_rule` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `pid` int(10) DEFAULT NULL COMMENT '父ID',
  `name` varchar(50) DEFAULT NULL COMMENT '名称',
  `title` varchar(50) DEFAULT '' COMMENT '标题',
  `remark` varchar(100) DEFAULT NULL COMMENT '备注',
  `ismenu` tinyint(1) DEFAULT NULL COMMENT '是否菜单',
  `createtime` int(10) DEFAULT NULL COMMENT '创建时间',
  `updatetime` int(10) DEFAULT NULL COMMENT '更新时间',
  `weigh` int(10) DEFAULT '0' COMMENT '权重',
  `status` enum('normal','hidden') DEFAULT NULL COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COMMENT='会员规则表';

-- ----------------------------
-- Records of fa_user_rule
-- ----------------------------
BEGIN;
INSERT INTO `fa_user_rule` VALUES (1, 0, 'index', '前台', '', 1, 1516168079, 1516168079, 1, 'normal');
INSERT INTO `fa_user_rule` VALUES (2, 0, 'api', 'API接口', '', 1, 1516168062, 1516168062, 2, 'normal');
INSERT INTO `fa_user_rule` VALUES (3, 1, 'user', '会员模块', '', 1, 1515386221, 1516168103, 12, 'normal');
INSERT INTO `fa_user_rule` VALUES (4, 2, 'user', '会员模块', '', 1, 1515386221, 1516168092, 11, 'normal');
INSERT INTO `fa_user_rule` VALUES (5, 3, 'index/user/login', '登录', '', 0, 1515386247, 1515386247, 5, 'normal');
INSERT INTO `fa_user_rule` VALUES (6, 3, 'index/user/register', '注册', '', 0, 1515386262, 1516015236, 7, 'normal');
INSERT INTO `fa_user_rule` VALUES (7, 3, 'index/user/index', '会员中心', '', 0, 1516015012, 1516015012, 9, 'normal');
INSERT INTO `fa_user_rule` VALUES (8, 3, 'index/user/profile', '个人资料', '', 0, 1516015012, 1516015012, 4, 'normal');
INSERT INTO `fa_user_rule` VALUES (9, 4, 'api/user/login', '登录', '', 0, 1515386247, 1515386247, 6, 'normal');
INSERT INTO `fa_user_rule` VALUES (10, 4, 'api/user/register', '注册', '', 0, 1515386262, 1516015236, 8, 'normal');
INSERT INTO `fa_user_rule` VALUES (11, 4, 'api/user/index', '会员中心', '', 0, 1516015012, 1516015012, 10, 'normal');
INSERT INTO `fa_user_rule` VALUES (12, 4, 'api/user/profile', '个人资料', '', 0, 1516015012, 1516015012, 3, 'normal');
COMMIT;

-- ----------------------------
-- Table structure for fa_user_score_log
-- ----------------------------
DROP TABLE IF EXISTS `fa_user_score_log`;
CREATE TABLE `fa_user_score_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会员ID',
  `score` int(10) NOT NULL DEFAULT '0' COMMENT '变更积分',
  `before` int(10) NOT NULL DEFAULT '0' COMMENT '变更前积分',
  `after` int(10) NOT NULL DEFAULT '0' COMMENT '变更后积分',
  `memo` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
  `createtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='会员积分变动表';

-- ----------------------------
-- Table structure for fa_user_token
-- ----------------------------
DROP TABLE IF EXISTS `fa_user_token`;
CREATE TABLE `fa_user_token` (
  `token` varchar(50) NOT NULL COMMENT 'Token',
  `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会员ID',
  `createtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `expiretime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '过期时间',
  PRIMARY KEY (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='会员Token表';

-- ----------------------------
-- Table structure for fa_version
-- ----------------------------
DROP TABLE IF EXISTS `fa_version`;
CREATE TABLE `fa_version`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `oldversion` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '旧版本号',
  `newversion` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '新版本号',
  `packagesize` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '包大小',
  `content` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '升级内容',
  `downloadurl` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '下载地址',
  `enforce` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '强制更新',
  `createtime` int(10) NOT NULL DEFAULT 0 COMMENT '创建时间',
  `updatetime` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间',
  `weigh` int(10) NOT NULL DEFAULT 0 COMMENT '权重',
  `status` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '状态',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '版本表' ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for fa_version
-- ----------------------------
BEGIN;
INSERT INTO `fa_version` (`id`, `oldversion`, `newversion`, `packagesize`, `content`, `downloadurl`, `enforce`, `createtime`, `updatetime`, `weigh`, `status`) VALUES
(1, '1.1.1,2', '1.2.1', '20M', '更新内容', 'http://www.andiff.net/download.html', 1, 1520425318, 0, 0, 'normal');
COMMIT;
-- ----------------------------
-- Table structure for fa_module  模型表
-- ----------------------------
DROP TABLE IF EXISTS `fa_module`;
CREATE TABLE `fa_module` (
  `itemid` varchar(36) NOT NULL COMMENT '主键',
  `dir` varchar(100) DEFAULT '' COMMENT '目录',
  `name` varchar(150) DEFAULT '' COMMENT '模型中文名称',
  `enname` varchar(150) DEFAULT '' COMMENT '模型英文名称',
  `pid` varchar(36) DEFAULT '0' COMMENT '上级模型',
  `catid` int(10) DEFAULT '0' COMMENT '类别',
  `filepath` varchar(100) DEFAULT '' COMMENT '文件地址',
  `sqlpath` varchar(100) DEFAULT '' COMMENT 'SQL文件地址',
  `intro` varchar(1000) DEFAULT '' COMMENT '简介',
  `createtime` int(10) DEFAULT '0' COMMENT '添加日期',
  `updatetime` int(10) DEFAULT '0' COMMENT '更新日期',
  PRIMARY KEY (`itemid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='模块';
BEGIN;
INSERT INTO `fa_module` VALUES ('cde39283e691429ea3786834ef892c66', '', '测试', 'test', '', '0', '','','<p>测试测试</p>', '1522918384', '1522918384');
COMMIT;
-- ----------------------------
-- Table structure for fa_module  数据列
-- ----------------------------
DROP TABLE IF EXISTS `fa_column`;
CREATE TABLE `fa_column` (
  `itemid` varchar(36) NOT NULL COMMENT '主键',
  `columnname` varchar(120) DEFAULT '' COMMENT '字段名称',
  `columnenname` varchar(120) DEFAULT '' COMMENT '英文标识',
  `columntype` varchar(50) DEFAULT '' COMMENT '字段类型',
  `columncheck` varchar(50) DEFAULT '' COMMENT '验证方式',
  `cname` varchar(40) DEFAULT '' COMMENT '模型名称',
  `rname` varchar(40) DEFAULT '' COMMENT '关联模型名称',
  `relate` tinyint(1) DEFAULT '0' COMMENT '关联类型。1|一对一2|多对一3|多对多4',
  `moduleid` varchar(36) DEFAULT '0' COMMENT '模型编号',
  `isintable` tinyint(1) DEFAULT '1' COMMENT '是否是表字段',
  `isshowlist` tinyint(1) DEFAULT '1' COMMENT '列表是否显示',
  `isshowadd` tinyint(1) DEFAULT '1' COMMENT '在添加界面是否显示',
  `isshowedit` tinyint(1) DEFAULT '1' COMMENT '编辑界面是否显示',
  `isshowwindow` tinyint(1) DEFAULT '1' COMMENT '弹出窗口是否显示',
  `isshowsearch` tinyint(1) DEFAULT '1' COMMENT '搜索的时候是否显示',
  `isoption` tinyint(1) DEFAULT '0' COMMENT '0不选择1单选2多选',
  `isimport` tinyint(1) DEFAULT '0' COMMENT '是否是可导入的字段',
  `options` varchar(200) DEFAULT '' COMMENT '选项',
  `optionform` varchar(20) DEFAULT '' COMMENT '选项的表现形式',
  `optionurl` varchar(200) DEFAULT '' COMMENT '获取选项的URL',
  `default` varchar(50) DEFAULT '' COMMENT '默认值',
  `listorder` int(10) DEFAULT '1' COMMENT '顺序',
  `intro` varchar(1600) DEFAULT '' COMMENT '内容简介',
  `createtime` int(10) DEFAULT '0',
  `updatetime` int(10) DEFAULT '0',
  PRIMARY KEY (`itemid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='字段';

-- ----------------------------
-- Records of fa_column
-- ----------------------------
BEGIN;
INSERT INTO `fa_column` VALUES ('23f461b1c8be4f85a163e9027fdb70a6', '付费方式', 'payment', 'varcharshort', '0', 'test', '', '0', 'cde39283e691429ea3786834ef892c66', '1', '1', '1', '1', '0', '1', '1', '0', '{\"1\":\"月付\",\"2\":\"季付\",\"3\":\"半年付\",\"4\":\"年付\"}', 'checkbox', '', '1', '6', '付费方式', '1523344873', '1523344873');
INSERT INTO `fa_column` VALUES ('2c17b7a84f514928a20ccc199f990187', '编号', 'itemid', 'identity', '0', 'test', '', '0', 'cde39283e691429ea3786834ef892c66', '1', '1', '0', '0', '0', '0', '0', '0', '', '0', '', '', '1', '主键', '1523340851', '1523340851');
INSERT INTO `fa_column` VALUES ('5bd11479db7244d8bfc82350a86a2916', '内容', 'content', 'text', '0', 'test', '', '0', 'cde39283e691429ea3786834ef892c66', '1', '0', '1', '1', '0', '0', '0', '0', '', '0', '', '', '8', '内容', '1523345000', '1523351849');
INSERT INTO `fa_column` VALUES ('6d237d48d40c4f659bbf0fe74b850768', '渠道', 'place', 'smallint', '0', 'test', '', '0', 'cde39283e691429ea3786834ef892c66', '1', '1', '1', '1', '0', '1', '1', '0', '{\"1\":\"官网\",\"2\":\"公众号\",\"3\":\"小程序\",\"4\":\"APP\"}', 'select', '', '1', '4', '渠道', '1523341489', '1523344563');
INSERT INTO `fa_column` VALUES ('7e99f33866a345fbb14210d4b6ecfeb3', '名称', 'title', 'varcharshort', 'required', 'test', '', '0', 'cde39283e691429ea3786834ef892c66', '1', '1', '1', '1', '0', '1', '0', '1', '', '0', '', '', '2', '名称', '1523340928', '1523340928');
INSERT INTO `fa_column` VALUES ('b620c9756823406fb61f5bd1ffca5f71', '类别', 'catid', 'int', '0', 'test', '', '0', 'cde39283e691429ea3786834ef892c66', '1', '1', '1', '1', '0', '1', '1', '0', '', 'select3', 'admin/ajax/readcategory?catid=0', '0', '5', '类别编号', '1523344727', '1523344727');
INSERT INTO `fa_column` VALUES ('c8b06d6131e848d2a810c109a1f7ef4a', '性别', 'gender', 'bool', '0', 'test', '', '0', 'cde39283e691429ea3786834ef892c66', '1', '1', '1', '1', '0', '1', '1', '0', '{\"1\":\"男\",\"2\":\"女\"}', 'radio', '', '1', '3', '性别', '1523341317', '1523341317');
COMMIT;
-- ----------------------------
-- Table structure for fa_province
-- ----------------------------
DROP TABLE IF EXISTS `fa_province`;
CREATE TABLE `fa_province` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) DEFAULT '' COMMENT '省份名称',
  `sort` tinyint(4) DEFAULT '0' COMMENT '显示顺序',
  `count` tinyint(4) DEFAULT '0' COMMENT '有开通城市',
  `no6` varchar(6) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=103 DEFAULT CHARSET=utf8 COMMENT='省份';

-- ----------------------------
-- Records of fa_province
-- ----------------------------
BEGIN;
INSERT INTO `fa_province` VALUES ('2', '天津市', '99', '0', '');
INSERT INTO `fa_province` VALUES ('3', '上海市', '98', '0', '');
INSERT INTO `fa_province` VALUES ('4', '重庆市', '97', '0', '');
INSERT INTO `fa_province` VALUES ('5', '河北省', '0', '0', '');
INSERT INTO `fa_province` VALUES ('6', '山西省', '0', '0', '');
INSERT INTO `fa_province` VALUES ('7', '台湾省', '0', '0', '');
INSERT INTO `fa_province` VALUES ('8', '辽宁省', '0', '0', '');
INSERT INTO `fa_province` VALUES ('9', '吉林省', '0', '0', '');
INSERT INTO `fa_province` VALUES ('10', '黑龙江省', '0', '0', '');
INSERT INTO `fa_province` VALUES ('11', '江苏省', '0', '0', '');
INSERT INTO `fa_province` VALUES ('12', '浙江省', '0', '0', '');
INSERT INTO `fa_province` VALUES ('13', '安徽省', '0', '0', '');
INSERT INTO `fa_province` VALUES ('14', '福建省', '78', '0', '');
INSERT INTO `fa_province` VALUES ('15', '江西省', '0', '0', '');
INSERT INTO `fa_province` VALUES ('16', '山东省', '0', '0', '');
INSERT INTO `fa_province` VALUES ('17', '河南省', '0', '0', '');
INSERT INTO `fa_province` VALUES ('18', '湖北省', '0', '0', '');
INSERT INTO `fa_province` VALUES ('19', '湖南省', '0', '0', '');
INSERT INTO `fa_province` VALUES ('20', '广东省', '0', '0', '');
INSERT INTO `fa_province` VALUES ('21', '甘肃省', '0', '0', '');
INSERT INTO `fa_province` VALUES ('22', '四川省', '0', '0', '');
INSERT INTO `fa_province` VALUES ('23', '贵州省', '0', '0', '');
INSERT INTO `fa_province` VALUES ('24', '海南省', '0', '0', '');
INSERT INTO `fa_province` VALUES ('25', '云南省', '0', '0', '');
INSERT INTO `fa_province` VALUES ('26', '青海省', '0', '0', '');
INSERT INTO `fa_province` VALUES ('27', '陕西省', '0', '0', '');
INSERT INTO `fa_province` VALUES ('28', '广西壮族自治区', '0', '0', '');
INSERT INTO `fa_province` VALUES ('29', '西藏自治区', '0', '0', '');
INSERT INTO `fa_province` VALUES ('30', '宁夏回族自治区', '0', '0', '');
INSERT INTO `fa_province` VALUES ('31', '新疆维吾尔自治区', '0', '0', '');
INSERT INTO `fa_province` VALUES ('32', '内蒙古自治区', '0', '0', '');
INSERT INTO `fa_province` VALUES ('33', '澳门特别行政区', '0', '0', '');
INSERT INTO `fa_province` VALUES ('34', '香港特别行政区', '0', '0', '');
INSERT INTO `fa_province` VALUES ('102', '北京市', '100', '0', '');
COMMIT;
-- ----------------------------
-- Table structure for fa_city
-- ----------------------------
DROP TABLE IF EXISTS `fa_city`;
CREATE TABLE `fa_city` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL DEFAULT '' COMMENT '|城市名称',
  `enname` varchar(100) NOT NULL DEFAULT '' COMMENT '城市名称（英文）',
  `countryid` int(10) DEFAULT '0' COMMENT '国家',
  `pid` int(10) DEFAULT '0' COMMENT '省份编号',
  `sort` smallint(4) DEFAULT '0' COMMENT '0|显示顺序',
  `wcode` varchar(10) DEFAULT '' COMMENT '天气编码',
  `acode` varchar(6) DEFAULT '' COMMENT '区号',
  `py` varchar(30) DEFAULT '0',
  `seed` int(11) DEFAULT '0' COMMENT '商户数量',
  `domain` varchar(30) DEFAULT '',
  `iparea` varchar(30) DEFAULT '',
  `template` varchar(30) DEFAULT '',
  `seo_title` varchar(255) DEFAULT '',
  `seo_keywords` varchar(255) DEFAULT '',
  `seo_description` varchar(255) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=395 DEFAULT CHARSET=utf8 COMMENT='城市';

-- ----------------------------
-- Records of fa_city
-- ----------------------------
BEGIN;
INSERT INTO `fa_city` VALUES ('1', '成都市', '', '37', '22', '29', '', '28', 'CDS', '5467', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('2', '自贡市', '', '37', '22', '23', '', '813', 'ZGS', '34', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('3', '攀枝花市', '', '37', '22', '25', '', '812', 'PZHS', '51', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('4', '泸州市', '', '37', '22', '26', '', '830', 'LZS', '54', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('5', '德阳市', '', '37', '22', '27', '', '838', 'DYS', '288', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('6', '绵阳市', '', '37', '22', '24', '', '816', 'MYS', '307', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('7', '广元市', '', '37', '22', '0', '', '839', 'GYS', '26', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('8', '遂宁市', '', '37', '22', '0', '', '825', 'SNS', '79', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('9', '内江市', '', '37', '22', '0', '', '8321', 'NJS', '72', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('10', '乐山市', '', '37', '22', '0', '', '8331', 'LSS', '144', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('11', '南充市', '', '37', '22', '0', '', '817', 'NCS', '136', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('12', '宜宾市', '', '37', '22', '0', '', '831', 'YBS', '257', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('13', '广安市', '', '37', '22', '0', '', '826', 'GAS', '170', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('14', '达州市', '', '37', '22', '0', '', '818', 'DZS', '214', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('15', '眉山市', '', '37', '22', '0', '', '8332', 'MSS', '66', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('16', '雅安市', '', '37', '22', '0', '', '835', 'YAS', '242', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('17', '巴中市', '', '37', '22', '0', '', '827', 'BZS', '178', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('18', '资阳市', '', '37', '22', '0', '', '8322', 'ZYS', '84', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('22', '台北市', '', '37', '7', '0', '', '861', 'TBS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('23', '天津市', '', '37', '2', '301', '', '22', 'TJS', '7602', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('24', '贺州市', '', '37', '28', '0', '', '7741', 'HZS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('25', '上海市', '', '37', '3', '0', '', '21', 'SHS', '23010', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('26', '长春市', '', '37', '9', '0', '', '431', 'CCS', '8594', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('27', '白城市', '', '37', '9', '0', '', '436', 'BCS', '2147', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('28', '松原市', '', '37', '9', '0', '', '438', 'SYS', '1523', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('29', '吉林市', '', '37', '9', '0', '', '432', 'JLS', '2637', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('30', '四平市', '', '37', '9', '0', '', '434', 'SPS', '779', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('31', '辽源市', '', '37', '9', '0', '', '437', 'LYS', '641', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('32', '通化市', '', '37', '9', '0', '', '435', 'THS', '1358', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('33', '白山市', '', '37', '9', '0', '', '439', 'BSS', '1728', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('34', '延边朝鲜族自治州', '', '37', '9', '0', '', '433', 'YBCXZZZZ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('35', '合肥市', '', '37', '13', '0', '', '551', 'HFS', '1371', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('36', '宿州市', '', '37', '13', '0', '', '557', 'SZS', '81', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('37', '淮北市', '', '37', '13', '0', '', '561', 'HBS', '39', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('38', '亳州市', '', '37', '13', '0', '', '5581', 'HZS', '86', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('39', '阜阳市', '', '37', '13', '0', '', '5582', 'FYS', '116', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('40', '蚌埠市', '', '37', '13', '0', '', '552', 'BBS', '63', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('41', '淮南市', '', '37', '13', '0', '', '554', 'HNS', '34', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('42', '滁州市', '', '37', '13', '0', '', '550', 'CZS', '165', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('43', '马鞍山市', '', '37', '13', '0', '', '555', 'MASS', '86', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('44', '芜湖市', '', '37', '13', '0', '', '553', 'WHS', '352', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('45', '铜陵市', '', '37', '13', '0', '', '562', 'TLS', '32', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('46', '安庆市', '', '37', '13', '0', '', '556', 'AQS', '253', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('47', '黄山市', '', '37', '13', '0', '', '559', 'HSS', '248', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('48', '六安市', '', '37', '13', '0', '', '564', 'LAS', '74', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('49', '巢湖市', '', '37', '13', '0', '', '565', 'CHS', '112', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('50', '池州市', '', '37', '13', '0', '', '566', 'CZS', '239', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('51', '宣城市', '', '37', '13', '0', '', '563', 'XCS', '188', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('52', '西宁市', '', '37', '26', '0', '', '971', 'XNS', '860', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('53', '海东地区', '', '37', '26', '0', '', '972', 'HDDQ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('54', '海北藏族自治州', '', '37', '26', '0', '', '970', 'HBCZZZZ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('55', '海南藏族自治州', '', '37', '26', '0', '', '974', 'HNCZZZZ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('56', '黄南藏族自治州', '', '37', '26', '0', '', '973', 'HNCZZZZ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('57', '果洛藏族自治州', '', '37', '26', '0', '', '975', 'GLCZZZZ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('58', '玉树藏族自治州', '', '37', '26', '0', '', '976', 'YSCZZZZ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('59', '海西蒙古族藏族自治州', '', '37', '26', '0', '', '977', 'HXMGZCZZZZ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('60', '昆明市', '', '37', '25', '0', '', '871', 'KMS', '3942', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('61', '曲靖市', '', '37', '25', '0', '', '874', 'QJS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('62', '玉溪市', '', '37', '25', '0', '', '877', 'YXS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('63', '保山市', '', '37', '25', '0', '', '875', 'BSS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('64', '昭通市', '', '37', '25', '0', '', '870', 'ZTS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('65', '丽江市', '', '37', '25', '0', '', '888', 'LJS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('66', '思茅市', '', '37', '25', '0', '', '879', 'SMS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('67', '临沧市', '', '37', '25', '0', '', '883', 'LCS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('68', '德宏傣族景颇族自治州', '', '37', '25', '0', '', '692', 'DHDZJPZZZZ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('69', '怒江傈僳族自治州', '', '37', '25', '0', '', '886', 'NJLSZZZZ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('70', '迪庆藏族自治州', '', '37', '25', '0', '', '887', 'DQCZZZZ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('71', '大理白族自治州', '', '37', '25', '0', '', '872', 'DLBZZZZ', '3', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('72', '楚雄彝族自治州', '', '37', '25', '0', '', '878', 'CXYZZZZ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('73', '红河哈尼族彝族自治州', '', '37', '25', '0', '', '873', 'HHHNZYZZZZ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('74', '文山壮族苗族自治州', '', '37', '25', '0', '', '876', 'WSZZMZZZZ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('75', '西双版纳傣族自治州', '', '37', '25', '0', '', '691', 'XSBNDZZZZ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('76', '济南市', '', '37', '16', '0', '', '531', 'JNS', '3392', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('77', '聊城市', '', '37', '16', '0', '', '635', 'LCS', '318', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('78', '德州市', '', '37', '16', '0', '', '534', 'DZS', '337', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('79', '东营市', '', '37', '16', '0', '', '546', 'DYS', '360', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('80', '淄博市', '', '37', '16', '0', '', '533', 'ZBS', '376', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('81', '潍坊市', '', '37', '16', '0', '', '536', 'WFS', '690', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('82', '烟台市', '', '37', '16', '0', '', '535', 'YTS', '1204', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('83', '威海市', '', '37', '16', '0', '', '631', 'WHS', '1031', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('84', '青岛市', '', '37', '16', '0', '', '532', 'QDS', '3719', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('85', '日照市', '', '37', '16', '0', '', '633', 'RZS', '105', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('86', '临沂市', '', '37', '16', '0', '', '539', 'LYS', '204', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('87', '枣庄市', '', '37', '16', '0', '', '632', 'ZZS', '78', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('88', '济宁市', '', '37', '16', '0', '', '537', 'JNS', '367', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('89', '泰安市', '', '37', '16', '0', '', '538', 'TAS', '623', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('90', '莱芜市', '', '37', '16', '0', '', '634', 'LWS', '149', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('91', '滨州市', '', '37', '16', '0', '', '543', 'BZS', '246', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('92', '菏泽市', '', '37', '16', '0', '', '530', 'HZS', '214', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('93', '福州市', '', '37', '14', '0', '', '591', 'FZS', '4010', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('94', '南平市', '', '37', '14', '0', '', '599', 'NPS', '322', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('95', '莆田市', '', '37', '14', '0', '', '594', 'PTS', '121', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('96', '三明市', '', '37', '14', '0', '', '598', 'SMS', '80', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('97', '泉州市', '', '37', '14', '0', '', '595', 'QZS', '484', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('98', '厦门市', '', '37', '14', '0', '', '592', 'XMS', '2999', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('99', '漳州市', '', '37', '14', '0', '', '596', 'ZZS', '105', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('100', '龙岩市', '', '37', '14', '0', '', '597', 'LYS', '293', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('101', '宁德市', '', '37', '14', '0', '', '593', 'NDS', '225', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('102', '北京市', '', '37', '102', '0', '', '10', 'BJS', '18916', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('103', '兰州市', '', '37', '21', '0', '', '931', 'LZS', '508', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('104', '嘉峪关市', '', '37', '21', '0', '', '9371', 'JYGS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('105', '金昌市', '', '37', '21', '0', '', '9351', 'JCS', '15', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('106', '白银市', '', '37', '21', '0', '', '943', 'BYS', '9', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('107', '天水市', '', '37', '21', '0', '', '938', 'TSS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('108', '武威市', '', '37', '21', '0', '', '9352', 'WWS', '22', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('109', '酒泉市', '', '37', '21', '0', '', '9372', 'JQS', '17', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('110', '张掖市', '', '37', '21', '0', '', '936', 'ZYS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('111', '庆阳市', '', '37', '21', '0', '', '934', 'QYS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('112', '平凉市', '', '37', '21', '0', '', '933', 'PLS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('113', '定西市', '', '37', '21', '0', '', '932', 'DXS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('114', '陇南市', '', '37', '21', '0', '', '939', 'LNS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('115', '临夏回族自治州', '', '37', '21', '0', '', '930', 'LXHZZZZ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('116', '甘南藏族自治州', '', '37', '21', '0', '', '941', 'GNCZZZZ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('117', '石家庄市', '', '37', '5', '0', '', '311', 'SJZS', '2159', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('118', '张家口市', '', '37', '5', '0', '', '313', 'ZJKS', '141', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('119', '承德市', '', '37', '5', '0', '', '314', 'CDS', '117', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('120', '秦皇岛市', '', '37', '5', '0', '', '335', 'QHDS', '275', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('121', '唐山市', '', '37', '5', '0', '', '315', 'TSS', '160', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('122', '廊坊市', '', '37', '5', '0', '', '316', 'LFS', '163', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('123', '保定市', '', '37', '5', '0', '', '312', 'BDS', '226', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('124', '衡水市', '', '37', '5', '0', '', '318', 'HSS', '125', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('125', '沧州市', '', '37', '5', '0', '', '317', 'CZS', '166', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('126', '邢台市', '', '37', '5', '0', '', '319', 'XTS', '84', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('127', '邯郸市', '', '37', '5', '0', '', '310', 'HDS', '165', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('128', '广州市', '', '37', '20', '0', '', '20', 'GZS', '9844', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('129', '清远市', '', '37', '20', '0', '', '763', 'QYS', '333', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('130', '韶关市', '', '37', '20', '0', '', '751', 'SGS', '183', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('131', '河源市', '', '37', '20', '0', '', '762', 'HYS', '136', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('132', '梅州市', '', '37', '20', '0', '', '753', 'MZS', '246', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('133', '潮州市', '', '37', '20', '0', '', '768', 'CZS', '222', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('134', '汕头市', '', '37', '20', '0', '', '754', 'STS', '191', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('135', '揭阳市', '', '37', '20', '0', '', '663', 'JYS', '134', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('136', '汕尾市', '', '37', '20', '0', '', '660', 'SWS', '189', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('137', '惠州市', '', '37', '20', '0', '', '752', 'HZS', '781', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('138', '东莞市', '', '37', '20', '0', '', '769', 'DGS', '7', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('139', '深圳市', '', '37', '20', '0', '', '755', 'SZS', '8401', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('140', '珠海市', '', '37', '20', '0', '', '756', 'ZHS', '1130', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('141', '中山市', '', '37', '20', '0', '', '760', 'ZSS', '4', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('142', '江门市', '', '37', '20', '0', '', '750', 'JMS', '624', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('143', '佛山市', '', '37', '20', '0', '', '757', 'FSS', '2678', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('144', '肇庆市', '', '37', '20', '0', '', '758', 'ZQS', '354', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('145', '云浮市', '', '37', '20', '0', '', '766', 'YFS', '178', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('146', '阳江市', '', '37', '20', '0', '', '662', 'YJS', '149', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('147', '茂名市', '', '37', '20', '0', '', '668', 'MMS', '370', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('148', '湛江市', '', '37', '20', '0', '', '759', 'ZJS', '91', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('149', '长沙市', '', '37', '19', '0', '', '731', 'CSS', '2370', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('150', '张家界市', '', '37', '19', '0', '', '744', 'ZJJS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('151', '常德市', '', '37', '19', '0', '', '736', 'CDS', '178', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('152', '益阳市', '', '37', '19', '0', '', '737', 'YYS', '155', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('153', '岳阳市', '', '37', '19', '0', '', '730', 'YYS', '154', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('154', '株洲市', '', '37', '19', '0', '', '733', 'ZZS', '216', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('155', '湘潭市', '', '37', '19', '0', '', '732', 'XTS', '207', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('156', '衡阳市', '', '37', '19', '0', '', '734', 'HYS', '185', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('157', '郴州市', '', '37', '19', '0', '', '735', 'CZS', '99', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('158', '永州市', '', '37', '19', '0', '', '746', 'YZS', '28', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('159', '邵阳市', '', '37', '19', '0', '', '739', 'SYS', '79', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('160', '怀化市', '', '37', '19', '0', '', '745', 'HHS', '52', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('161', '娄底市', '', '37', '19', '0', '', '738', 'LDS', '55', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('162', '湘西土家族苗族自治州', '', '37', '19', '0', '', '743', 'XXTJZMZZZZ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('163', '郑州市', '', '37', '17', '0', '', '371', 'ZZS', '1910', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('164', '三门峡市', '', '37', '17', '0', '', '398', 'SMXS', '99', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('165', '洛阳市', '', '37', '17', '0', '', '379', 'LYS', '376', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('166', '焦作市', '', '37', '17', '0', '', '3911', 'JZS', '113', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('167', '新乡市', '', '37', '17', '0', '', '373', 'XXS', '157', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('168', '鹤壁市', '', '37', '17', '0', '', '392', 'HBS', '85', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('169', '安阳市', '', '37', '17', '0', '', '372', 'AYS', '134', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('170', '濮阳市', '', '37', '17', '0', '', '393', 'PYS', '200', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('171', '开封市', '', '37', '17', '0', '', '378', 'KFS', '79', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('172', '商丘市', '', '37', '17', '0', '', '370', 'SQS', '92', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('173', '许昌市', '', '37', '17', '0', '', '374', 'XCS', '120', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('174', '漯河市', '', '37', '17', '0', '', '395', 'LHS', '59', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('175', '平顶山市', '', '37', '17', '0', '', '375', 'PDSS', '92', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('176', '南阳市', '', '37', '17', '0', '', '377', 'NYS', '161', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('177', '信阳市', '', '37', '17', '0', '', '376', 'XYS', '84', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('178', '周口市', '', '37', '17', '0', '', '394', 'ZKS', '189', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('179', '驻马店市', '', '37', '17', '0', '', '396', 'ZMDS', '33', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('181', '呼和浩特市', '', '37', '32', '0', '', '471', 'HHHTS', '549', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('182', '包头市', '', '37', '32', '0', '', '472', 'BTS', '51', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('183', '乌海市', '', '37', '32', '0', '', '473', 'WHS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('184', '赤峰市', '', '37', '32', '0', '', '476', 'CFS', '44', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('185', '通辽市', '', '37', '32', '0', '', '475', 'TLS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('186', '呼伦贝尔市', '', '37', '32', '0', '', '470', 'HLBES', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('187', '鄂尔多斯市', '', '37', '32', '0', '', '477', 'EEDSS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('188', '乌兰察布市', '', '37', '32', '0', '', '474', 'WLCBS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('189', '巴彦淖尔市', '', '37', '32', '0', '', '478', 'BYNES', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('190', '兴安盟', '', '37', '32', '0', '', '482', 'XAM', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('191', '锡林郭勒盟', '', '37', '32', '0', '', '479', 'XLGLM', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('192', '阿拉善盟', '', '37', '32', '0', '', '483', 'ALSM', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('193', '太原市', '', '37', '6', '0', '', '351', 'TYS', '782', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('194', '朔州市', '', '37', '6', '0', '', '349', 'SZS', '15', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('195', '大同市', '', '37', '6', '0', '', '352', 'DTS', '84', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('196', '阳泉市', '', '37', '6', '0', '', '353', 'YQS', '16', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('197', '长治市', '', '37', '6', '0', '', '355', 'CZS', '27', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('198', '晋城市', '', '37', '6', '0', '', '356', 'JCS', '42', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('199', '忻州市', '', '37', '6', '0', '', '350', 'XZS', '21', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('200', '晋中市', '', '37', '6', '0', '', '354', 'JZS', '53', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('201', '临汾市', '', '37', '6', '0', '', '357', 'LFS', '64', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('202', '吕梁市', '', '37', '6', '0', '', '358', 'LLS', '20', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('203', '运城市', '', '37', '6', '0', '', '359', 'YCS', '35', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('204', '澳门特别行政区', '', '37', '33', '0', '', '62', 'AMTBXZQ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('205', '乌鲁木齐市', '', '37', '31', '0', '', '991', 'WLMQS', '670', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('206', '克拉玛依市', '', '37', '31', '0', '', '990', 'KLMYS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('208', '喀什地区', '', '37', '31', '0', '', '9989', 'KSDQ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('209', '阿克苏地区', '', '37', '31', '0', '', '9979', 'AKSDQ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('210', '和田地区', '', '37', '31', '0', '', '903', 'HTDQ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('211', '吐鲁番地区', '', '37', '31', '0', '', '995', 'TLFDQ', '54', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('212', '哈密地区', '', '37', '31', '0', '', '902', 'HMDQ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('213', '克孜勒苏柯尔克孜自治州', '', '37', '31', '0', '', '908', 'KZLSKEKZZZ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('214', '博尔塔拉蒙古自治州', '', '37', '31', '0', '', '909', 'BETLMGZZZ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('215', '昌吉回族自治州', '', '37', '31', '0', '', '9949', 'CJHZZZZ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('216', '巴音郭楞蒙古自治州', '', '37', '31', '0', '', '996', 'BYGLMGZZZ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('217', '伊犁哈萨克自治州', '', '37', '31', '0', '', '999', 'YLHSKZZZ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('218', '塔城地区', '', '37', '31', '0', '', '901', 'TCDQ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('219', '阿勒泰地区', '', '37', '31', '0', '', '906', 'ALTDQ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('220', '银川市', '', '37', '30', '0', '', '951', 'YCS', '244', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('221', '石嘴山市', '', '37', '30', '0', '', '952', 'SZSS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('222', '吴忠市', '', '37', '30', '0', '', '953', 'WZS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('223', '固原市', '', '37', '30', '0', '', '954', 'GYS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('224', '中卫市', '', '37', '30', '0', '', '955', 'ZWS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('225', '阿坝藏族羌族自治州', '', '37', '22', '0', '', '837', 'ABCZQZZZZ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('226', '甘孜藏族自治州', '', '37', '22', '0', '', '836', 'GZCZZZZ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('227', '凉山彝族自治州', '', '37', '22', '0', '', '834', 'LSYZZZZ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('228', '重庆市', '', '37', '4', '0', '', '23', 'ZQS', '5764', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('229', '杭州市', '', '37', '12', '0', '', '571', 'HZS', '8385', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('230', '湖州市', '', '37', '12', '0', '', '572', 'HZS', '489', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('231', '嘉兴市', '', '37', '12', '0', '', '573', 'JXS', '1469', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('232', '舟山市', '', '37', '12', '0', '', '580', 'ZSS', '462', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('233', '宁波市', '', '37', '12', '0', '', '574', 'NBS', '3342', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('234', '绍兴市', '', '37', '12', '0', '', '575', 'SXS', '1065', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('235', '衢州市', '', '37', '12', '0', '', '570', 'QZS', '260', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('236', '金华市', '', '37', '12', '0', '', '579', 'JHS', '884', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('237', '台州市', '', '37', '12', '0', '', '576', 'TZS', '730', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('238', '温州市', '', '37', '12', '0', '', '577', 'WZS', '1829', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('239', '丽水市', '', '37', '12', '0', '', '578', 'LSS', '611', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('240', '香港特别行政区', '', '37', '34', '0', '', '61', 'XGTBXZQ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('241', '哈尔滨市', '', '37', '10', '0', '', '451', 'HEBS', '3060', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('242', '七台河市', '', '37', '10', '0', '', '464', 'QTHS', '9', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('243', '齐齐哈尔市', '', '37', '10', '0', '', '452', 'QQHES', '25', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('244', '黑河市', '', '37', '10', '0', '', '456', 'HHS', '30', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('245', '大庆市', '', '37', '10', '0', '', '459', 'DQS', '99', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('246', '鹤岗市', '', '37', '10', '0', '', '468', 'HGS', '2', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('247', '伊春市', '', '37', '10', '0', '', '458', 'YCS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('248', '佳木斯市', '', '37', '10', '0', '', '454', 'JMSS', '15', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('249', '双鸭山市', '', '37', '10', '0', '', '469', 'SYSS', '7', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('250', '鸡西市', '', '37', '10', '0', '', '467', 'JXS', '23', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('251', '牡丹江市', '', '37', '10', '0', '', '453', 'MDJS', '40', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('252', '绥化市', '', '37', '10', '0', '', '455', 'SHS', '34', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('253', '大兴安岭地区', '', '37', '10', '0', '', '457', 'DXALDQ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('254', '西安市', '', '37', '27', '0', '', '29', 'XAS', '4281', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('255', '延安市', '', '37', '27', '0', '', '911', 'YAS', '60', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('256', '铜川市', '', '37', '27', '0', '', '919', 'TCS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('257', '渭南市', '', '37', '27', '0', '', '913', 'WNS', '60', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('258', '咸阳市', '', '37', '27', '0', '', '910', 'XYS', '33', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('259', '宝鸡市', '', '37', '27', '0', '', '917', 'BJS', '35', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('260', '汉中市', '', '37', '27', '0', '', '916', 'HZS', '43', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('261', '榆林市', '', '37', '27', '0', '', '912', 'YLS', '38', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('262', '安康市', '', '37', '27', '0', '', '915', 'AKS', '15', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('263', '商洛市', '', '37', '27', '0', '', '914', 'SLS', '5', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('264', '南昌市', '', '37', '15', '0', '', '791', 'NCS', '935', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('265', '九江市', '', '37', '15', '0', '', '792', 'JJS', '62', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('266', '景德镇市', '', '37', '15', '0', '', '798', 'JDZS', '21', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('267', '鹰潭市', '', '37', '15', '0', '', '701', 'YTS', '33', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('268', '新余市', '', '37', '15', '0', '', '790', 'XYS', '7', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('269', '萍乡市', '', '37', '15', '0', '', '799', 'PXS', '15', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('270', '赣州市', '', '37', '15', '0', '', '797', 'GZS', '107', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('271', '上饶市', '', '37', '15', '0', '', '793', 'SRS', '78', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('272', '抚州市', '', '37', '15', '0', '', '794', 'FZS', '29', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('273', '宜春市', '', '37', '15', '0', '', '795', 'YCS', '39', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('274', '吉安市', '', '37', '15', '0', '', '796', 'JAS', '39', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('275', '贵阳市', '', '37', '23', '0', '', '851', 'GYS', '923', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('276', '六盘水市', '', '37', '23', '0', '', '858', 'LPSS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('277', '遵义市', '', '37', '23', '0', '', '852', 'ZYS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('278', '安顺市', '', '37', '23', '0', '', '853', 'ASS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('279', '毕节地区', '', '37', '23', '0', '', '857', 'BJDQ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('280', '铜仁地区', '', '37', '23', '0', '', '856', 'TRDQ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('281', '黔东南苗族侗族自治州', '', '37', '23', '0', '', '855', 'QDNMZDZZZZ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('282', '黔南布依族苗族自治州', '', '37', '23', '0', '', '854', 'QNBYZMZZZZ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('283', '黔西南布依族苗族自治州', '', '37', '23', '0', '', '859', 'QXNBYZMZZZ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('284', '海口市', '', '37', '24', '0', '', '8981', 'HKS', '2737', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('285', '三亚市', '', '37', '24', '0', '', '8982', 'SYS', '1511', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('287', '武汉市', '', '37', '18', '0', '', '27', 'WHS', '3974', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('288', '十堰市', '', '37', '18', '0', '', '719', 'SYS', '58', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('289', '襄樊市', '', '37', '18', '0', '', '710', 'XFS', '74', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('290', '荆门市', '', '37', '18', '0', '', '724', 'JMS', '54', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('291', '孝感市', '', '37', '18', '0', '', '712', 'XGS', '94', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('292', '黄冈市', '', '37', '18', '0', '', '713', 'HGS', '85', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('293', '鄂州市', '', '37', '18', '0', '', '711', 'EZS', '13', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('294', '黄石市', '', '37', '18', '0', '', '714', 'HSS', '70', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('295', '咸宁市', '', '37', '18', '0', '', '715', 'XNS', '55', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('296', '荆州市', '', '37', '18', '0', '', '716', 'JZS', '78', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('297', '宜昌市', '', '37', '18', '0', '', '717', 'YCS', '152', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('298', '随州市', '', '37', '18', '0', '', '722', 'SZS', '22', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('299', '恩施土家族苗族自治州', '', '37', '18', '0', '', '718', 'ESTJZMZZZZ', '15', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('300', '南京市', '', '37', '11', '0', '', '25', 'NJS', '4498', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('301', '徐州市', '', '37', '11', '0', '', '516', 'XZS', '590', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('302', '连云港市', '', '37', '11', '0', '', '518', 'LYGS', '119', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('303', '宿迁市', '', '37', '11', '0', '', '527', 'SQS', '73', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('304', '淮安市', '', '37', '11', '0', '', '517', 'HAS', '206', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('305', '盐城市', '', '37', '11', '0', '', '515', 'YCS', '206', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('306', '扬州市', '', '37', '11', '0', '', '514', 'YZS', '761', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('307', '泰州市', '', '37', '11', '0', '', '523', 'TZS', '147', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('308', '南通市', '', '37', '11', '0', '', '513', 'NTS', '614', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('309', '镇江市', '', '37', '11', '0', '', '511', 'ZJS', '669', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('310', '常州市', '', '37', '11', '0', '', '519', 'CZS', '407', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('311', '无锡市', '', '37', '11', '0', '', '510', 'WXS', '1760', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('312', '苏州市', '', '37', '11', '0', '', '512', 'SZS', '2185', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('313', '沈阳市', '', '37', '8', '0', '', '24', 'SYS', '3801', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('314', '朝阳市', '', '37', '8', '0', '', '421', 'CYS', '15', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('315', '阜新市', '', '37', '8', '0', '', '418', 'FXS', '58', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('316', '铁岭市', '', '37', '8', '0', '', '410', 'TLS', '88', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('317', '抚顺市', '', '37', '8', '0', '', '413', 'FSS', '151', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('318', '本溪市', '', '37', '8', '0', '', '414', 'BXS', '18', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('319', '辽阳市', '', '37', '8', '0', '', '419', 'LYS', '65', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('320', '鞍山市', '', '37', '8', '0', '', '412', 'ASS', '75', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('321', '丹东市', '', '37', '8', '0', '', '415', 'DDS', '137', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('322', '大连市', '', '37', '8', '0', '', '411', 'DLS', '2967', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('323', '营口市', '', '37', '8', '0', '', '417', 'YKS', '32', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('324', '盘锦市', '', '37', '8', '0', '', '427', 'PJS', '78', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('325', '锦州市', '', '37', '8', '0', '', '416', 'JZS', '119', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('326', '葫芦岛市', '', '37', '8', '0', '', '429', 'HLDS', '343', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('327', '拉萨市', '', '37', '29', '0', '', '891', 'LSS', '174', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('328', '那曲地区', '', '37', '29', '0', '', '896', 'NQDQ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('329', '昌都地区', '', '37', '29', '0', '', '895', 'CDDQ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('330', '林芝地区', '', '37', '29', '0', '', '894', 'LZDQ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('331', '山南地区', '', '37', '29', '0', '', '893', 'SNDQ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('332', '日喀则地区', '', '37', '29', '0', '', '892', 'RKZDQ', '8', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('333', '阿里地区', '', '37', '29', '0', '', '897', 'ALDQ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('334', '南宁市', '', '37', '28', '0', '', '771', 'NNS', '1121', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('335', '桂林市', '', '37', '28', '0', '', '773', 'GLS', '293', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('336', '柳州市', '', '37', '28', '0', '', '772', 'LZS', '313', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('337', '梧州市', '', '37', '28', '0', '', '7742', 'WZS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('338', '贵港市', '', '37', '28', '0', '', '775', 'GGS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('339', '玉林市', '', '37', '28', '0', '', '7759', 'YLS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('340', '钦州市', '', '37', '28', '0', '', '777', 'QZS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('341', '北海市', '', '37', '28', '0', '', '779', 'BHS', '57', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('342', '防城港市', '', '37', '28', '0', '', '770', 'FCGS', '115', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('343', '崇左市', '', '37', '28', '0', '', '7719', 'CZS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('344', '百色市', '', '37', '28', '0', '', '776', 'BSS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('345', '河池市', '', '37', '28', '0', '', '778', 'HCS', '19', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('346', '来宾市', '', '37', '28', '0', '', '7729', 'LBS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('347', '高雄市', '', '37', '7', '0', '', '868', 'GXS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('348', '基隆市', '', '37', '7', '0', '', '862', 'JLS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('349', '台中市', '', '37', '7', '0', '', '8648', 'TZS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('350', '台南市', '', '37', '7', '0', '', '8679', 'TNS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('351', '新竹市', '', '37', '7', '0', '', '8631', 'XZS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('352', '嘉义市', '', '37', '7', '0', '', '866', 'JYS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('353', '台北县', '', '37', '7', '0', '', '8621', 'TBX', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('354', '宜兰县', '', '37', '7', '0', '', '8622', 'YLX', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('355', '桃园县', '', '37', '7', '0', '', '8632', 'TYX', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('356', '新竹县', '', '37', '7', '0', '', '8633', 'XZX', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('357', '苗栗县', '', '37', '7', '0', '', '60', 'MLX', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('358', '台中县', '', '37', '7', '0', '', '8649', 'TZX', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('359', '彰化县', '', '37', '7', '0', '', '8658', 'ZHX', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('360', '南投县', '', '37', '7', '0', '', '8659', 'NTX', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('361', '云林县', '', '37', '7', '0', '', '8668', 'YLX', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('362', '嘉义县', '', '37', '7', '0', '', '8669', 'JYX', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('363', '台南县', '', '37', '7', '0', '', '8678', 'TNX', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('364', '高雄县', '', '37', '7', '0', '', '8688', 'GXX', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('365', '屏东县', '', '37', '7', '0', '', '8698', 'PDX', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('366', '台东县', '', '37', '7', '0', '', '8699', 'TDX', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('367', '花莲县', '', '37', '7', '0', '', '8697', 'HLX', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('368', '澎湖县', '', '37', '7', '0', '', '8689', 'PHX', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('369', '济源市', '', '37', '17', '0', '', '3912', 'JYS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('370', '仙桃市', '', '37', '18', '0', '', '7287', 'XTS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('371', '天门市', '', '37', '18', '0', '', '7288', 'TMS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('372', '潜江市', '', '37', '18', '0', '', '7289', 'QJS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('373', '神农架林区', '', '37', '18', '0', '', '7199', 'SNJLQ', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('374', '石河子市', '', '37', '31', '0', '', '993', 'SHZS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('375', '阿拉尔市', '', '37', '31', '0', '', '9978', 'ALES', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('376', '图木舒克市', '', '37', '31', '0', '', '9988', 'TMSKS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('377', '五家渠市', '', '37', '31', '0', '', '9948', 'WJQS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('378', '文昌市', '', '37', '24', '0', '', '8983', 'WCS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('379', '琼海市', '', '37', '24', '0', '', '8984', 'QHS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('380', '万宁市', '', '37', '24', '0', '', '8985', 'WNS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('381', '五指山市', '', '37', '24', '0', '', '8986', 'WZSS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('382', '东方市', '', '37', '24', '0', '', '8987', 'DFS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('383', '儋州市', '', '37', '24', '0', '', '8988', 'DZS', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('384', '临高县', '', '37', '24', '0', '', '89899', 'LGX', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('385', '澄迈县', '', '37', '24', '0', '', '8980', 'CMX', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('386', '定安县', '', '37', '24', '0', '', '89898', 'DAX', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('387', '屯昌县', '', '37', '24', '0', '', '89897', 'TCX', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('388', '昌江黎族自治县', '', '37', '24', '0', '', '89896', 'CJLZZZX', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('389', '白沙黎族自治县', '', '37', '24', '0', '', '89895', 'BSLZZZX', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('390', '琼中黎族苗族自治县', '', '37', '24', '0', '', '89894', 'QZLZMZZZX', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('391', '陵水黎族自治县', '', '37', '24', '0', '', '89892', 'LSLZZZX', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('392', '保亭黎族苗族自治县', '', '37', '24', '0', '', '89891', 'BTLZMZZZX', '1', '', '', '', '', '', '');
INSERT INTO `fa_city` VALUES ('393', '乐东黎族自治县', '', '37', '24', '0', '', '89890', 'LDLZZZX', '1', '', '', '', '', '', '');
COMMIT;
DROP TABLE IF EXISTS `fa_memberlogin`;
CREATE TABLE `fa_memberlogin` (
  `updatetime` int(10) NOT NULL DEFAULT '0' COMMENT '更新日期',
  `createtime` int(10) NOT NULL DEFAULT '0' COMMENT '添加日期',
  `logintime` int(10) NOT NULL DEFAULT '0' COMMENT '登录时间',
  `loginip` varchar(100) NOT NULL DEFAULT '' COMMENT '登录IP',
  `prevtime` int(10) NOT NULL DEFAULT '0' COMMENT '上次登录',
  `token` varchar(400) NOT NULL DEFAULT '' COMMENT 'TOKEN',
  `isauth` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否验证',
  `auth` varchar(100) NOT NULL DEFAULT '' COMMENT '验证密钥',
  `invitecode` varchar(100) NOT NULL DEFAULT '' COMMENT '邀请码',
  `inviter` varchar(36) NOT NULL DEFAULT '' COMMENT '邀请人',
  `email` varchar(100) NOT NULL DEFAULT '' COMMENT '邮箱',
  `groupid` varchar(36) NOT NULL DEFAULT '' COMMENT '会员组',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态',
  `mobile` varchar(100) NOT NULL DEFAULT '' COMMENT '手机号',
  `payword` varchar(100) NOT NULL DEFAULT '' COMMENT '支付密码',
  `password` varchar(100) NOT NULL DEFAULT '' COMMENT '密码',
  `username` varchar(100) NOT NULL DEFAULT '' COMMENT '用户名',
  `itemid` varchar(36) NOT NULL COMMENT '编号',
  PRIMARY KEY (`itemid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
DROP TABLE IF EXISTS `fa_memberinfo`;
CREATE TABLE `fa_memberinfo` (
  `memberid` varchar(36) NOT NULL DEFAULT '' COMMENT '登录编号',
  `updatetime` int(10) NOT NULL DEFAULT '0' COMMENT '更新日期',
  `createtime` int(10) NOT NULL DEFAULT '0' COMMENT '添加日期',
  `content` mediumtext COMMENT '简介',
  `bankaccount` varchar(100) NOT NULL DEFAULT '' COMMENT '银行账户',
  `bank` varchar(100) NOT NULL DEFAULT '' COMMENT '开户银行',
  `lockmoney` decimal(4,2) NOT NULL DEFAULT '0.00' COMMENT '锁定余额',
  `money` decimal(4,2) NOT NULL DEFAULT '0.00' COMMENT '资金余额',
  `sms` int(10) NOT NULL DEFAULT '0' COMMENT '短信',
  `credit` int(10) NOT NULL DEFAULT '0' COMMENT '积分',
  `message` int(10) NOT NULL DEFAULT '0' COMMENT '最新消息数量',
  `areaid` int(10) NOT NULL DEFAULT '0' COMMENT '区县',
  `cityid` int(10) NOT NULL DEFAULT '0' COMMENT '城市',
  `provinceid` int(10) NOT NULL DEFAULT '0' COMMENT '省份',
  `country` varchar(100) NOT NULL DEFAULT '' COMMENT '国家',
  `weixin` varchar(100) NOT NULL DEFAULT '' COMMENT '微信',
  `ali` varchar(100) NOT NULL DEFAULT '' COMMENT '阿里旺旺',
  `alipay` varchar(100) NOT NULL DEFAULT '' COMMENT '支付宝',
  `skype` varchar(100) NOT NULL DEFAULT '' COMMENT 'SKYPE',
  `qq` varchar(100) NOT NULL DEFAULT '' COMMENT 'QQ',
  `avatar` varchar(100) NOT NULL DEFAULT '' COMMENT '头像',
  `email` varchar(100) NOT NULL DEFAULT '' COMMENT '邮件',
  `phone` varchar(100) NOT NULL DEFAULT '' COMMENT '电话',
  `mobile` varchar(100) NOT NULL DEFAULT '' COMMENT '手机',
  `gender` tinyint(1) NOT NULL DEFAULT '1' COMMENT '性别',
  `nickname` varchar(100) DEFAULT '' COMMENT '昵称',
  `truename` varchar(100) NOT NULL DEFAULT '' COMMENT '真实姓名',
  `itemid` varchar(36) NOT NULL COMMENT '编号',
  PRIMARY KEY (`itemid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
DROP TABLE IF EXISTS `fa_membergroup`;
CREATE TABLE `fa_membergroup` (
  `updatetime` int(10) NOT NULL DEFAULT '0' COMMENT '修改日期',
  `createtime` int(10) NOT NULL DEFAULT '0' COMMENT '添加日期',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态',
  `rules` varchar(1000) NOT NULL DEFAULT '' COMMENT '权限',
  `name` varchar(100) NOT NULL DEFAULT '' COMMENT '名称',
  `itemid` varchar(36) NOT NULL COMMENT '编号',
  PRIMARY KEY (`itemid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
DROP TABLE IF EXISTS `fa_memberauth`;
CREATE TABLE `fa_memberauth` (
  `updatetime` int(10) NOT NULL DEFAULT '0' COMMENT '更新日期',
  `createtime` int(10) NOT NULL DEFAULT '0' COMMENT '创建日期',
  `memberid` varchar(36) NOT NULL DEFAULT '' COMMENT '会员编号',
  `intro` varchar(1000) NOT NULL DEFAULT '' COMMENT '简介',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态',
  `authvalue` varchar(1000) NOT NULL DEFAULT '' COMMENT '资料内容',
  `auth` varchar(400) NOT NULL DEFAULT '' COMMENT '资料名称',
  `itemid` varchar(36) NOT NULL COMMENT '编号',
  PRIMARY KEY (`itemid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

SET FOREIGN_KEY_CHECKS = 1;
